Tabela ServiceType

Definicja tabeli ServiceType

Name

ServiceType

Code

ServiceType

Comment

 


Lista kolumn tabeli ServiceType

Name

Code

ServiceTypeID

ServiceTypeID

PerfServiceStatusID

PerfServiceStatusID

Active

Active

Serv_ServiceTypeID

Serv_ServiceTypeID

DefaultResultStatusID

DefaultResultStatusID


Kolumna ServiceTypeID tabeli ServiceType

Definicja kolumny ServiceTypeID tabeli ServiceType

Name

ServiceTypeID

Code

ServiceTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfServiceStatusID tabeli ServiceType

Definicja kolumny PerfServiceStatusID tabeli ServiceType

Name

PerfServiceStatusID

Code

PerfServiceStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli ServiceType

Definicja kolumny Active tabeli ServiceType

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Serv_ServiceTypeID tabeli ServiceType

Definicja kolumny Serv_ServiceTypeID tabeli ServiceType

Name

Serv_ServiceTypeID

Code

Serv_ServiceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DefaultResultStatusID tabeli ServiceType

Definicja kolumny DefaultResultStatusID tabeli ServiceType

Name

DefaultResultStatusID

Code

DefaultResultStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli ServiceType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ServiceType

Definicja klucza Identifier_1 tabeli ServiceType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment